CREATE PROCEDURE [dbo].[asi_GetPublishRequestDetails]
    @PublishRequestKey uniqueidentifier,
    @PublishServerCode nchar(1)
AS
BEGIN
    SELECT PublishRequestDetailKey
      FROM PublishRequestDetail prd, DocumentMain dm
     WHERE prd.PublishServerCode = @PublishServerCode
       AND prd.PublishRequestKey = @PublishRequestKey
       AND prd.ContentDocumentKey = dm.DocumentKey
       AND ((dm.DocumentStatusCode IN (30,40) AND prd.IsDelete = 0)
             OR (dm.DocumentStatusCode IN (70,80) AND prd.IsDelete = 1))
       AND ((PublishRequestStatusCode = 0 AND (PublishedDateTime IS NULL OR PublishedDateTime <= GetDate()))
            OR
            (PublishRequestStatusCode = 1 AND prd.IsDelete = 0 AND
            (DATEADD(second, prd.Frequency, prd.PublishedDateTime) <= GetDate())
               AND (prd.Frequency <> 0))
            )
END

GO